Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# PROCESSES

Property | Description
--- | ---
Parameter type | Integer
Default value | 40 to operating system-dependent
Modifiable | No
Range of values | 6 to operating system dependent
Basic | Yes
Real Application Clusters | Multiple instances can have different values.

`PROCESSES` specifies the maximum number of operating system user processes that can simultaneously connect to Oracle. Its value should allow for all background processes such as locks, job queue processes, and parallel execution processes.

The default values of the `SESSIONS` and `TRANSACTIONS` parameters are derived from this parameter. Therefore, if you change the value of `PROCESSES`, you should evaluate whether to adjust the values of those derived parameters.

See Also: Oracle Database Administrator's Guide for information on setting this parameter in exclusive mode Oracle Database Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide for information on setting this parameter in a Real Application Clusters environment Your operating system-specific Oracle documentation for the range of values